package com.chenfan.finance.model.vo;

import cn.afterturn.easypoi.excel.annotation.Excel;
import lombok.Data;

import java.math.BigDecimal;
import java.time.LocalDateTime;

@Data
public class InvoiceSettlementExportVO {

    @Excel(name = "结算单号", orderNum = "1")
    private String settlementNo;

    @Excel(name = "制单人", orderNum = "2")
    private String createBy;

    @Excel(name = "单据状态",
            replace = {"已开票_1", "未开票_0"," _null"},
            orderNum = "3")
    private Integer state;

    @Excel(name = "品牌", orderNum = "4")
    private String brandName;

    @Excel(name = "供应商", orderNum = "5")
    private String vendorAbbName;

    @Excel(name = "结算开始时间", orderNum = "6")
    private String settlementStartDate;

    @Excel(name = "结算截止日期", orderNum = "7")
    private String settlementEndDate;

    @Excel(name = "货号", orderNum = "8")
    private String productCode;

    @Excel(name = "货品名称", orderNum = "9")
    private String productName;

    @Excel(name = "不含税单价", orderNum = "10")
    private BigDecimal freeTaxPrice;

    @Excel(name = "加价不含税单价", orderNum = "11")
    private BigDecimal upFreeTaxPrice;

    @Excel(name = "到货数量", orderNum = "12")
    private Integer arrivalQty;

    @Excel(name = "退次数量", orderNum = "13")
    private Integer defectiveRejectionQty;

    @Excel(name = "拒收数量", orderNum = "14")
    private Integer rejectionQty;

    @Excel(name = "历史未结算日期", orderNum = "15")
    private String historyUnCountDate;

    @Excel(name = "历史未结算截止日期", orderNum = "16")
    private String historyUnCountDateEnd;

    @Excel(name = "历史结算数量", orderNum = "17")
    private Integer historyCount;

    @Excel(name = "本期结算数量", orderNum = "18")
    private Integer settlementQty;

    @Excel(name = "本期结算金额", orderNum = "19")
    private BigDecimal settlementAmount;

    @Excel(name = "不含税总金额", orderNum = "20")
    private BigDecimal freeTaxTotalPrice;

    @Excel(name = "税额", orderNum = "21")
    private BigDecimal taxPrice;

    @Excel(name = "质检扣费", orderNum = "22")
    private BigDecimal qaDeductions;

    @Excel(name = "红字扣费", orderNum = "23")
    private BigDecimal redDeductions;

    @Excel(name = "税差", orderNum = "24")
    private BigDecimal taxDiff;

    @Excel(name = "其他扣费", orderNum = "25")
    private BigDecimal othersDeductions;

    @Excel(name = "延期数量", orderNum = "26")
    private Integer delayCount;

    @Excel(name = "延期扣款金额", orderNum = "27")
    private BigDecimal postponeDeductionsTotal;

    @Excel(name = "预付款合同金额", orderNum = "28")
    private BigDecimal advancepayAmount;

    @Excel(name = "预付款实付金额", orderNum = "29")
    private BigDecimal advancepayAmountActual;

    @Excel(name = "本期实付金额", orderNum = "30")
    private BigDecimal realMoney;

    @Excel(name = "开票时间", orderNum = "31")
    private String purchaseInvoiceDate;

    @Excel(name = "发票号码", orderNum = "32")
    private String purchaseInvoiceNo;

    @Excel(name = "制单日期", orderNum = "33")
    private String createTime;

    @Excel(name = "审核人", orderNum = "34")
    private String auditBy;

    @Excel(name = "备注", orderNum = "35")
    private String remark;

    @Excel(name = "供应商id", orderNum = "36")
    private Integer vendorId;

}

